You can use this report to review discrepancies in the inventory count. For example, you can look for items that have a big difference between the system count and the physical inventory count. These items are likely candidates for a recount. The inventory reconciliation report shows the reconciled and un-reconciled physical inventories for the selected inventory location. It also calculates the On hand value, Physical Inventoried value, and any difference based on the Calculate Value you select. When a physical inventory is created, Voyager takes a snapshot of the inventory levels at that moment and will use the values at the time of that snapshot for comparisons. You can select the Use Current On Hand Qty check box if you would prefer to compare to the inventory values in the system at the time the report is generated.
The following fields for the Inventory Reconciliation report require explanation:
|
You can choose to report the Onhand Value and Physical Inventoried Value based on the (Item Type Cost Price, Item Type Billing Price, or Inventory Average Cost).
|
|
|
Changes the Qty Difference calculation. It subtracts the value in the Quantity On Hand column from the value in the Physical Inventoried Qty column.
|
|
|
You can choose to sort by (Item Type, Location Type, Category, Qty Difference, or Value Difference).The inventory reconciliation report is typically sorted by quantity difference, value difference, item type, or category. The Summarized By field is not available for this report.
|
|
|
The value in this column is calculated by subtracting the value in the Qty On Hand At Physical Inventory column from the value in the Physical Inventoried Qty column unless the Use Current On Hand Qty option is selected. If that option is selected, the difference is calculated by subtracting the value in the Quantity On Hand column from the value in the Physical Inventoried Qty column.
|
